Time series gardeen

Dataset statistics

Number of variables	8
Number of observations	9000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	562.6 KiB
Average record size in memory	64.0 B

Variable types

TimeSeries	8

Timeseries statistics

Number of series	8
Time series length	9000
Starting point	0
Ending point	8999
Period	1

Original
Scaled

Alerts

`dht_air_humidity` is highly overall correlated with `dht_ground_humidity` and 1 other fields	High correlation
`dht_air_temperature` is highly overall correlated with `dht_ground_humidity` and 2 other fields	High correlation
`dht_ground_humidity` is highly overall correlated with `dht_air_humidity` and 2 other fields	High correlation
`dht_ground_temperature` is highly overall correlated with `dht_air_temperature`	High correlation
`light_air` is highly overall correlated with `light_ground`	High correlation
`light_ground` is highly overall correlated with `light_air`	High correlation
`timestamp` is highly overall correlated with `dht_air_humidity` and 2 other fields	High correlation
`timestamp` is non stationary	Non stationary
`light_air` is non stationary	Non stationary
`light_ground` is non stationary	Non stationary
`moisture_ground` is non stationary	Non stationary
`dht_air_humidity` is non stationary	Non stationary
`dht_air_temperature` is non stationary	Non stationary
`dht_ground_humidity` is non stationary	Non stationary
`dht_ground_temperature` is non stationary	Non stationary
`light_air` is seasonal	Seasonal
`light_ground` is seasonal	Seasonal
`moisture_ground` is seasonal	Seasonal
`dht_air_humidity` is seasonal	Seasonal
`dht_air_temperature` is seasonal	Seasonal
`dht_ground_humidity` is seasonal	Seasonal
`dht_ground_temperature` is seasonal	Seasonal
`timestamp` has unique values	Unique
`light_air` has 5015 (55.7%) zeros	Zeros
`light_ground` has 3597 (40.0%) zeros	Zeros

Reproduction

Analysis started	2024-04-12 21:59:02.108668
Analysis finished	2024-04-12 21:59:26.955627
Duration	24.85 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

timestamp
Numeric time series

HIGH CORRELATION NON STATIONARY UNIQUE

Distinct	9000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.6972166 × 10⁹
Minimum	1.6970634 × 10⁹
Maximum	1.6973758 × 10⁹
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	1.6970634 × 10⁹
5-th percentile	1.6970789 × 10⁹
Q1	1.6971403 × 10⁹
median	1.697215 × 10⁹
Q3	1.6972896 × 10⁹
95-th percentile	1.6973593 × 10⁹
Maximum	1.6973758 × 10⁹
Range	312468
Interquartile range (IQR)	149314.5

Descriptive statistics

Standard deviation	89028.741
Coefficient of variation (CV)	5.2455732 × 10^-5
Kurtosis	-1.1500781
Mean	1.6972166 × 10⁹
Median Absolute Deviation (MAD)	74665.5
Skewness	0.057722304
Sum	1.527495 × 10¹³
Variance	7.9261167 × 10⁹
Monotonicity	Strictly increasing
Augmented Dickey-Fuller test p-value	0.9981966536

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
1697063380	1	< 0.1%
1697264685	1	< 0.1%
1697264481	1	< 0.1%
1697264515	1	< 0.1%
1697264548	1	< 0.1%
1697264581	1	< 0.1%
1697264616	1	< 0.1%
1697264649	1	< 0.1%
1697264718	1	< 0.1%
1697264415	1	< 0.1%
Other values (8990)	8990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1697063380	1	< 0.1%
1697063416	1	< 0.1%
1697063450	1	< 0.1%
1697063484	1	< 0.1%
1697063518	1	< 0.1%
1697063553	1	< 0.1%
1697063587	1	< 0.1%
1697063619	1	< 0.1%
1697063652	1	< 0.1%
1697063685	1	< 0.1%

Value	Count	Frequency (%)
1697375848	1	< 0.1%
1697375815	1	< 0.1%
1697375779	1	< 0.1%
1697375745	1	< 0.1%
1697375712	1	< 0.1%
1697375678	1	< 0.1%
1697375644	1	< 0.1%
1697375600	1	< 0.1%
1697375567	1	< 0.1%
1697375528	1	< 0.1%

ACF and PACF

light_air
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL ZEROS

Distinct	1660
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	506.29311
Minimum	0
Maximum	2736
Zeros	5015
Zeros (%)	55.7%
Memory size	70.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	944
95-th percentile	1911.35
Maximum	2736
Range	2736
Interquartile range (IQR)	944

Descriptive statistics

Standard deviation	715.04248
Coefficient of variation (CV)	1.4123093
Kurtosis	0.54397794
Mean	506.29311
Median Absolute Deviation (MAD)	0
Skewness	1.2487838
Sum	4556638
Variance	511285.75
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.02039248909

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
0	5015	55.7%
1600	20	0.2%
1072	17	0.2%
80	14	0.2%
912	14	0.2%
1535	14	0.2%
592	13	0.1%
1424	13	0.1%
1603	12	0.1%
1520	12	0.1%
Other values (1650)	3856	42.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5015	55.7%
1	1	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
6	2	< 0.1%
7	2	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%

Value	Count	Frequency (%)
2736	1	< 0.1%
2732	2	< 0.1%
2731	1	< 0.1%
2730	2	< 0.1%
2727	1	< 0.1%
2725	5	0.1%
2722	1	< 0.1%
2721	3	< 0.1%
2715	1	< 0.1%
2714	3	< 0.1%

ACF and PACF

light_ground
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL ZEROS

Distinct	1946
Distinct (%)	21.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	947.46078
Minimum	0
Maximum	3568
Zeros	3597
Zeros (%)	40.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	13
Q3	2114
95-th percentile	2879
Maximum	3568
Range	3568
Interquartile range (IQR)	2114

Descriptive statistics

Standard deviation	1148.4086
Coefficient of variation (CV)	1.212091
Kurtosis	-1.2941499
Mean	947.46078
Median Absolute Deviation (MAD)	13
Skewness	0.60852967
Sum	8527147
Variance	1318842.4
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.2689754405

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
0	3597	40.0%
1	227	2.5%
2	188	2.1%
3	138	1.5%
16	121	1.3%
6	56	0.6%
5	55	0.6%
4	50	0.6%
2096	44	0.5%
7	43	0.5%
Other values (1936)	4481	49.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3597	40.0%
1	227	2.5%
2	188	2.1%
3	138	1.5%
4	50	0.6%
5	55	0.6%
6	56	0.6%
7	43	0.5%
8	11	0.1%
9	31	0.3%

Value	Count	Frequency (%)
3568	1	< 0.1%
3493	1	< 0.1%
3492	1	< 0.1%
3491	1	< 0.1%
3490	2	< 0.1%
3488	1	< 0.1%
3487	2	< 0.1%
3486	1	< 0.1%
3485	1	< 0.1%
3482	1	< 0.1%

ACF and PACF

moisture_ground
Numeric time series

NON STATIONARY SEASONAL

Distinct	1455
Distinct (%)	16.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1604.9336
Minimum	0
Maximum	2161
Zeros	32
Zeros (%)	0.4%
Memory size	70.4 KiB

Quantile statistics

Minimum	0
5-th percentile	854
Q1	1489
median	1666
Q3	1872
95-th percentile	2026
Maximum	2161
Range	2161
Interquartile range (IQR)	383

Descriptive statistics

Standard deviation	380.22386
Coefficient of variation (CV)	0.23690941
Kurtosis	3.7961341
Mean	1604.9336
Median Absolute Deviation (MAD)	196
Skewness	-1.7092623
Sum	14444402
Variance	144570.18
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	2.535678426 × 10^-7

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
1520	94	1.0%
1535	91	1.0%
1552	91	1.0%
1936	73	0.8%
1840	66	0.7%
1872	62	0.7%
1904	57	0.6%
1808	49	0.5%
1856	39	0.4%
1584	38	0.4%
Other values (1445)	8340	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	32	0.4%
1	1	< 0.1%
2	1	< 0.1%
11	1	< 0.1%
13	2	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
21	1	< 0.1%
23	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
2161	2	< 0.1%
2160	1	< 0.1%
2159	2	< 0.1%
2155	3	< 0.1%
2154	1	< 0.1%
2151	1	< 0.1%
2149	1	< 0.1%
2145	1	< 0.1%
2144	4	< 0.1%
2140	1	< 0.1%

ACF and PACF

dht_air_humidity
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	29
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	45.674
Minimum	31
Maximum	59
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	31
5-th percentile	34
Q1	36
median	45
Q3	57
95-th percentile	58
Maximum	59
Range	28
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	9.6793664
Coefficient of variation (CV)	0.2119229
Kurtosis	-1.6874392
Mean	45.674
Median Absolute Deviation (MAD)	10
Skewness	0.1542927
Sum	411066
Variance	93.690134
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.9055436408

Histogram with fixed size bins (bins=29)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
58	1159	12.9%
35	1074	11.9%
37	780	8.7%
57	764	8.5%
36	576	6.4%
56	546	6.1%
55	533	5.9%
45	527	5.9%
39	386	4.3%
34	382	4.2%
Other values (19)	2273	25.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	36	0.4%
32	174	1.9%
33	81	0.9%
34	382	4.2%
35	1074	11.9%
36	576	6.4%
37	780	8.7%
38	289	3.2%
39	386	4.3%
40	232	2.6%

Value	Count	Frequency (%)
59	340	3.8%
58	1159	12.9%
57	764	8.5%
56	546	6.1%
55	533	5.9%
54	150	1.7%
53	54	0.6%
52	34	0.4%
51	21	0.2%
50	11	0.1%

ACF and PACF

dht_air_temperature
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	57
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.805978
Minimum	20.2
Maximum	25.8
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	20.2
5-th percentile	21.6
Q1	22.1
median	22.7
Q3	23.4
95-th percentile	24.2
Maximum	25.8
Range	5.6
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	0.9193466
Coefficient of variation (CV)	0.04031165
Kurtosis	0.077134087
Mean	22.805978
Median Absolute Deviation (MAD)	0.7
Skewness	0.42456098
Sum	205253.8
Variance	0.84519818
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.06571204902

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
23	512	5.7%
21.7	498	5.5%
21.8	457	5.1%
22.5	415	4.6%
22.9	402	4.5%
22.8	401	4.5%
23.1	395	4.4%
22.3	375	4.2%
21.9	365	4.1%
22.7	361	4.0%
Other values (47)	4819	53.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.2	10	0.1%
20.3	10	0.1%
20.4	9	0.1%
20.5	10	0.1%
20.6	7	0.1%
20.7	14	0.2%
20.8	28	0.3%
20.9	21	0.2%
21	18	0.2%
21.1	24	0.3%

Value	Count	Frequency (%)
25.8	32	0.4%
25.7	17	0.2%
25.6	16	0.2%
25.5	14	0.2%
25.4	17	0.2%
25.3	16	0.2%
25.2	14	0.2%
25.1	17	0.2%
25	14	0.2%
24.9	21	0.2%

ACF and PACF

dht_ground_humidity
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	35
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	47.618889
Minimum	31
Maximum	65
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	31
5-th percentile	36
Q1	38
median	44
Q3	59
95-th percentile	63
Maximum	65
Range	34
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	10.399353
Coefficient of variation (CV)	0.21838715
Kurtosis	-1.6315051
Mean	47.618889
Median Absolute Deviation (MAD)	8
Skewness	0.26626366
Sum	428570
Variance	108.14655
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.8416900958

Histogram with fixed size bins (bins=35)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
38	1164	12.9%
59	805	8.9%
37	702	7.8%
62	657	7.3%
58	657	7.3%
36	646	7.2%
39	465	5.2%
40	382	4.2%
44	376	4.2%
43	362	4.0%
Other values (25)	2784	30.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	27	0.3%
32	69	0.8%
33	35	0.4%
34	84	0.9%
35	104	1.2%
36	646	7.2%
37	702	7.8%
38	1164	12.9%
39	465	5.2%
40	382	4.2%

Value	Count	Frequency (%)
65	42	0.5%
64	78	0.9%
63	353	3.9%
62	657	7.3%
61	214	2.4%
60	339	3.8%
59	805	8.9%
58	657	7.3%
57	166	1.8%
56	78	0.9%

ACF and PACF

dht_ground_temperature
Numeric time series

HIGH CORRELATION NON STATIONARY SEASONAL

Distinct	71
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.181189
Minimum	18.3
Maximum	25.8
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	18.3
5-th percentile	20.3
Q1	21.1
median	22.2
Q3	23.2
95-th percentile	24.1
Maximum	25.8
Range	7.5
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.2684739
Coefficient of variation (CV)	0.057186921
Kurtosis	-0.58078213
Mean	22.181189
Median Absolute Deviation (MAD)	1
Skewness	0.18119503
Sum	199630.7
Variance	1.609026
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.0597276072

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
23.7	493	5.5%
22.8	346	3.8%
22.7	338	3.8%
21.8	337	3.7%
22.9	313	3.5%
21.4	295	3.3%
21.1	292	3.2%
21.3	268	3.0%
23.8	263	2.9%
22.1	258	2.9%
Other values (61)	5797	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.3	1	< 0.1%
18.4	1	< 0.1%
18.5	1	< 0.1%
18.8	2	< 0.1%
19.2	1	< 0.1%
19.3	1	< 0.1%
19.4	8	0.1%
19.5	16	0.2%
19.6	21	0.2%
19.7	25	0.3%

Value	Count	Frequency (%)
25.8	29	0.3%
25.7	21	0.2%
25.6	26	0.3%
25.5	19	0.2%
25.4	30	0.3%
25.3	8	0.1%
25.2	7	0.1%
25.1	7	0.1%
25	8	0.1%
24.9	16	0.2%

ACF and PACF

Auto

Heatmap
Table

	dht_air_humidity	dht_air_temperature	dht_ground_humidity	dht_ground_temperature	light_air	light_ground	moisture_ground	timestamp
dht_air_humidity	1.000	-0.402	0.932	-0.267	-0.151	-0.037	-0.163	0.717
dht_air_temperature	-0.402	1.000	-0.547	0.959	0.026	-0.039	-0.115	-0.613
dht_ground_humidity	0.932	-0.547	1.000	-0.435	-0.227	-0.131	-0.187	0.701
dht_ground_temperature	-0.267	0.959	-0.435	1.000	0.110	0.079	-0.119	-0.470
light_air	-0.151	0.026	-0.227	0.110	1.000	0.916	0.086	-0.042
light_ground	-0.037	-0.039	-0.131	0.079	0.916	1.000	0.250	0.141
moisture_ground	-0.163	-0.115	-0.187	-0.119	0.086	0.250	1.000	0.221
timestamp	0.717	-0.613	0.701	-0.470	-0.042	0.141	0.221	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	timestamp	light_air	light_ground	moisture_ground	dht_air_humidity	dht_air_temperature	dht_ground_humidity	dht_ground_temperature
0	1697063380	2311	1999	944	40	24.4	40	24.3
1	1697063416	2325	2006	929	40	24.3	40	24.3
2	1697063450	2320	2003	952	40	24.3	40	24.3
3	1697063484	2329	1999	950	40	24.3	40	24.2
4	1697063518	2307	1983	961	40	24.3	40	24.2
5	1697063553	2330	1985	961	40	24.3	40	24.2
6	1697063587	2321	1998	931	40	24.3	40	24.1
7	1697063619	2316	1977	942	40	24.3	40	24.1
8	1697063652	2311	1980	966	40	24.3	40	24.1
9	1697063685	2317	1983	976	41	24.3	40	24.1

	timestamp	light_air	light_ground	moisture_ground	dht_air_humidity	dht_air_temperature	dht_ground_humidity	dht_ground_temperature
8990	1697375528	723	2519	1321	57	21.9	58	21.8
8991	1697375567	714	2512	1233	57	21.9	58	21.8
8992	1697375600	713	2517	1424	57	21.9	58	21.8
8993	1697375644	695	2527	1319	57	21.9	58	21.8
8994	1697375678	693	2505	1358	57	21.9	58	21.8
8995	1697375712	678	2465	1249	57	21.9	58	21.8
8996	1697375745	655	2419	1232	57	21.9	58	21.8
8997	1697375779	629	2410	206	57	21.9	58	21.8
8998	1697375815	661	2352	1351	57	21.9	58	21.8
8999	1697375848	639	2340	1232	57	21.9	58	21.8

Overview

Variables

Interactions

Correlations

Missing values

Sample